package com.hs.sfzy.mapper;

import com.hs.sfzy.entity.Coursemark;

import java.util.List;

public interface CoursemarkMapper {
    List<Coursemark> selectAll(Coursemark coursemark);

    int deleteById(int id);

    int insert(Coursemark coursemark);
    List<Coursemark> selectByAvgGrade();

    // 根据课程id查评价
    List<Coursemark> selectByCourseId(Long courseId);

    // 根据课程id获取课程的评价数
    Integer countCoursemarkByCourseId(Long courseId);
}
